UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'wwaRc4XJS1VtcaOwXeYfW5VrIawWbtNd6nr7lK4K7S4='
WHERE
key_id = '306bd2bb011cbd00edd00265c3f46c992d5c609d98907bcd7353f72ff025f4a1'
AND (
token = 'wwaRc4XJS1VtcaOwXeYfW5VrIawWbtNd6nr7lK4K7S4='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)