UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wZFMXi5YJF2W1MYtnVglWDT50mBgz1OlXVSMnO1bdjc='
WHERE
key_id = '524b1376f980fb7e712f5cec1151d6fb839f81234d024c8ce213b3d79a4c6f8f'
AND (
token = 'wZFMXi5YJF2W1MYtnVglWDT50mBgz1OlXVSMnO1bdjc='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)