UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '5kJGG861rywBL9RJM5de4wHcueTUls3wrYDLoIoMQLw='
WHERE
key_id = '6e78873d5e2f9a5757e2cf65420d158ee9a978551e87cece1f5c2166e15a7abc'
AND (
token = '5kJGG861rywBL9RJM5de4wHcueTUls3wrYDLoIoMQLw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)