UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'Xt4pAodR5ECY+H6p9tgAmZ0hy31wk9X+APGzh51yFz0='
WHERE
key_id = '431772e93b4e58aefb416e707afdb3f09910103ad726118d7122e88a1f521a24'
AND (
token = 'Xt4pAodR5ECY+H6p9tgAmZ0hy31wk9X+APGzh51yFz0='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)