UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '7Gv2HZGuzrurx1F5ReWMVqPcy8Ju99Baa5sMnMSVp2E='
WHERE
key_id = 'f54397123f6375433ed1c973a2d70360d97d77fa0b13fa7d4cb876fccad50855'
AND (
token = '7Gv2HZGuzrurx1F5ReWMVqPcy8Ju99Baa5sMnMSVp2E='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)