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