UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '/U8E88iJ7U5SY0PLZMl9/GWi8lZyIKecwX/t7Ntfbps='
WHERE
key_id = 'd4ea92b89063224054c76fe8d9bf2e6ea81229f65b3302fdbe972865f415bf7b'
AND (
token = '/U8E88iJ7U5SY0PLZMl9/GWi8lZyIKecwX/t7Ntfbps='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)