UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pc+DkbEwj3T8bWfl7JH+AeUz4PRjVNIJUkBY8JdWtSA='
WHERE
key_id = 'b3adbd7614f8e5442535f84851041a6c528b3eeb1bac5de7378d5c2e84484e1b'
AND (
token = 'pc+DkbEwj3T8bWfl7JH+AeUz4PRjVNIJUkBY8JdWtSA='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)