UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Vki2XfkF3BDZ6p3Xz4Ab0ddjrbu9I6vY61zt5J/ElCg='
WHERE
key_id = '372b3fe54d664b0803e3e2f7d26428fbeb480ce010ce945774f7dc83be5896fa'
AND (
token = 'Vki2XfkF3BDZ6p3Xz4Ab0ddjrbu9I6vY61zt5J/ElCg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)