UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'XEn05yYWQ6YzD3hiBpGnMN+3KEvWdMF2yI7zyZV6Syg='
WHERE
key_id = '275ee138b97dc35ab9fc994f2457862b68d77028658f57b3eb51449056691c33'
AND (
token = 'XEn05yYWQ6YzD3hiBpGnMN+3KEvWdMF2yI7zyZV6Syg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)