UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'JKu1SOpKcldShJ8mbpkXh6loHSKaxK7bu0eul4kVOC8='
WHERE
key_id = 'a9bb9892dcfc904be7f6b6deb8564f70f3850331ff397b19aad9d9778daf2951'
AND (
token = 'JKu1SOpKcldShJ8mbpkXh6loHSKaxK7bu0eul4kVOC8='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)