UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '4nFnFuDHibQ7//E1q7iTzaKtJ3aVmse98GAQeMtFvR8='
WHERE
key_id = '4c95ab9ed8911308e550dc310820997ee9784b04d8de6f0f7c44f1981a0f503c'
AND (
token = '4nFnFuDHibQ7//E1q7iTzaKtJ3aVmse98GAQeMtFvR8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)