UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'R6fVNST8kJMHfOYD7Uz0Vz8FSkdP7xmUXvov86shKbQ='
WHERE
key_id = 'a95179fc3b77afd670a32649288c3b87e18d25716f074b356b94dd99c54438b6'
AND (
token = 'R6fVNST8kJMHfOYD7Uz0Vz8FSkdP7xmUXvov86shKbQ='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)