UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'uacO0eCHZL5/kcvULbIz2aCPq5wfMnErWAe1lkOVtig='
WHERE
key_id = 'b0019e07ab89a879d12dc398a7eb2c733ee31c27cc3d322a9df4a7e11a5ccb4f'
AND (
token = 'uacO0eCHZL5/kcvULbIz2aCPq5wfMnErWAe1lkOVtig='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)