UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'YyILwePzZ+VrJYg33lHxzvTZ7RaX97kmNIf12oyra14='
WHERE
key_id = 'd6f2f4ba8ffab256eed3ab55021838e4dcfac36eb168d9709496db8e8deb7914'
AND (
token = 'YyILwePzZ+VrJYg33lHxzvTZ7RaX97kmNIf12oyra14='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)