UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = '6UczmCrvpwWdH+LUQegw/ep09lwcvc4KiujWa2VnXM8='
WHERE
key_id = '1649c365ecd24d253b83927a11e45452ab536d55134c45ca0084c92d78c36bf0'
AND (
token = '6UczmCrvpwWdH+LUQegw/ep09lwcvc4KiujWa2VnXM8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)