UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'qBexZJQh3go1NwxvPaX8Lx6gqueUtd6l1/KQRWi0SPM='
WHERE
key_id = 'ca589e5d13ba378681351af4d9335670f833705935ade7205d130fb8c5c7e8f5'
AND (
token = 'qBexZJQh3go1NwxvPaX8Lx6gqueUtd6l1/KQRWi0SPM='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)