UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '47S3tMdWswfefrxM4PF4CbnlJjVmKwsBsF4JaQLmVHg='
WHERE
key_id = '6eab8b31a4664981e50b093f40a467ef0a6cd9abf00810acf51e187da3b13a66'
AND (
token = '47S3tMdWswfefrxM4PF4CbnlJjVmKwsBsF4JaQLmVHg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)