UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'DOxfAdqnsGjccucyGXeOu1ir4G4u0YukiBvbndlHCew='
WHERE
key_id = '9b522fabca2da6852daea5ddb48a7aeece0089307a8f44c3f240486092c287a4'
AND (
token = 'DOxfAdqnsGjccucyGXeOu1ir4G4u0YukiBvbndlHCew='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)