UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '8VR8nshjPCV2y3hWPAJ9RT5BHmYiH2PsJvyYXapOKhU='
WHERE
key_id = 'fc7ec74895c7cb9fa76668c78a05fc5764e5e4918158904eb52c2064739c0940'
AND (
token = '8VR8nshjPCV2y3hWPAJ9RT5BHmYiH2PsJvyYXapOKhU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)