UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'd/EHg9hsSF015o0W4pLwe1sLVu4+uYEnp7jwf8xzRqU='
WHERE
key_id = 'a3623ec05bae49fde6a87a91799bbfd126938206340c7da42939f857f96dc200'
AND (
token = 'd/EHg9hsSF015o0W4pLwe1sLVu4+uYEnp7jwf8xzRqU='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)