UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'jdWbPgbpasDnExs+T4iN4gcl/MYWdfglyIrBvLAe4bg='
WHERE
key_id = 'a1e265922312581d9b81f8174682ba6f0dbac465b88b6914ed2647bb964fb78a'
AND (
token = 'jdWbPgbpasDnExs+T4iN4gcl/MYWdfglyIrBvLAe4bg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)