UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'KUS5ecnuKhGEj8npfIpafLCYlafqm2Rf/iDj0eI4XBw='
WHERE
key_id = '2583a871c7edab34f5c6095908c4d1cdf38e1bf9f0f4f2128108a7aba77a028a'
AND (
token = 'KUS5ecnuKhGEj8npfIpafLCYlafqm2Rf/iDj0eI4XBw='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)