UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pMehZq7t6IfH/hoMgSi3iY56kAJKT63CU8yJqrWYic0='
WHERE
key_id = '29742d53378f107cbeeabb43bdfc0338b101141afa96cbb29de178694d891bf5'
AND (
token = 'pMehZq7t6IfH/hoMgSi3iY56kAJKT63CU8yJqrWYic0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)