UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'pi2KKpDlMsQVuWQR1ioXA8kNovOuG05p1foLFU2JZZw='
WHERE
key_id = '7238c53ec6cf99e761bb23e6d3c913a9e29a3c0e4bcdf5dd958ca9bf42360dce'
AND (
token = 'pi2KKpDlMsQVuWQR1ioXA8kNovOuG05p1foLFU2JZZw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)