UPDATE
cscart_lock_keys
SET
expiry_at = UNIX_TIMESTAMP(NOW()) + 30,
token = 'r9Dyc3dJtkr360ejoB1dXMx+tl+X/YIQ21D6Ug//4hg='
WHERE
key_id = '02177ace2a7ee3707f61db8cca81d4de3a31428f9f39a1bfb1cadb4c2a69097b'
AND (
token = 'r9Dyc3dJtkr360ejoB1dXMx+tl+X/YIQ21D6Ug//4hg='
OR expiry_at <= UNIX_TIMESTAMP(NOW())
)