UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'dGcNlzmhvz5Cgk1jNLvm17b5vI64U/3l0LVJq4Np6Dw='
WHERE
key_id = 'bfa5fcf194749637a853f9d01a10ef1a36fc3c7a4ec4c7fe99e35464250a9b9c'
AND (
token = 'dGcNlzmhvz5Cgk1jNLvm17b5vI64U/3l0LVJq4Np6Dw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)