UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'nlXJcmpmB+UOLRZWMn+5hi+E+8gVO5GDFdrAsX/eEO0='
WHERE
key_id = '6ba21c7dfc669ec25d02133d151796d272e3171deeffdbd3d456fb43100b492a'
AND (
token = 'nlXJcmpmB+UOLRZWMn+5hi+E+8gVO5GDFdrAsX/eEO0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)