UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XT5wG3Wm46pO0r+0hNUwP0nNeDZeV+LjU2nHPv0mOQw='
WHERE
key_id = '8c83672d185bfc163aa00a52861e14420663064a826a778ace835e2d8470523f'
AND (
token = 'XT5wG3Wm46pO0r+0hNUwP0nNeDZeV+LjU2nHPv0mOQw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)