UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8WDp40vgS3Ob9tnaga5DmLrAMF/aAJqPqh2N6xbIChc='
WHERE
key_id = '3820c3d838d8d7eb4520def6a16279dc3dba98827decf1ade9169a846e22eeee'
AND (
token = '8WDp40vgS3Ob9tnaga5DmLrAMF/aAJqPqh2N6xbIChc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)