UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'alJq1nmFwx1Bex0V5oQJp1lEaM5Fbeln7BEn3R4uyic='
WHERE
key_id = '28e1e49efb64e361b9de9badfd7c20dca24603044f81e4a24c544cc6f89f396a'
AND (
token = 'alJq1nmFwx1Bex0V5oQJp1lEaM5Fbeln7BEn3R4uyic='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)