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